const ADODB2 = require('node-adodb');
// const connection2 = ADODB2.open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\AccessControl\\ICCard3000.MDB;jet oledb:database password=168168;');
const connection2 = ADODB2.open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\AccessControl\\2022.db;');
//query操作的是有返回量的，比如查询
//execute操作是没有返回量的
// connection2.query('update t_d_SwipeRecord set f_IsUpdate = 1;').then((data: any) => {
//     console.log(data);
// }).catch((err: any) => {
//     console.log(err);
// })
connection2.query('select * from VHICLECATALOG').then((data: any) => {
    console.log(data);
}).catch((err: any) => {
    console.log(err);
})